All Questions
Tagged with databaseweb-development
68 questions
2votes
1answer
239views
What is an optimal system design for tracking product views per user that is scalable?
I have a web application that contains products and users. There are 10,000+ products and 100,000+ users to give a sense of the scale that's required. For some application specific reasons, I need to ...
- 29
-2votes
2answers
241views
Designing a database schema for a website related to my town's history
I am working on digitizing old photographs, articles, ephemera, etc. related to my town's history, and I've been tasked to put these scans I've made onto a website for the public to see. There are ...
- 13
1vote
0answers
40views
Storing SQL for table creation
I am currently working on a small web-app stored in a monorepo and using PSQL as database (hosted on GCP). It's my first time working for a web app and I have to create a lot of tables manually such ...
0votes
1answer
136views
Sync customers between shop and CRM-system (two-way)
I have a shop system that is based on a MySQL database and over which I have full control. On this system runs my synchronization plugin. And then there is an external CRM system with a fixed API. ...
- 131
4votes
3answers
830views
Why not use SQL to query an API instead of GraphQL?
nalzok posted an interesting question over a year ago: "Why not use SQL instead of GraphQL?". Respondents seem to suggest three main problems: One should not directly expose one's database ...
- 157
3votes
2answers
479views
Storing a function body inside a database table
Let us say that for a web application, inside the source code of the app you created a function called calculateAmount. Inside the web app, you need to call that function. But for some reason, due ...
-4votes
1answer
67views
How to create a quiz app without multiple choice?
So I'm trying to make a quiz app where the answers should be typed rather than multiple choice. However, even though there is always one right answer, in english, we have many ways of writing the same ...
1vote
0answers
1kviews
How to store articles (with text and images) in SQLAlchemy database
I'm working on a blog-like application with Flask and SQLAlchemy and I'm unsure how to store the blog posts (articles) in the database. These are going to contain text and images (placed between ...
2votes
1answer
519views
How to handle frequent update requests to an API which is connected to the database?
In a document editing web application such as Google Docs or Evernote, sync/save has to happen almost instantaneously to make sure data loss is minimal in case of a connection failure or a client ...
- 29
43votes
5answers
16kviews
Why not use SQL instead of GraphQL?
Recently I learned about GraphQL which claims to be superior to RESTful. However, I started wondering why don't we simply put SQL statements into an HTTP GET request. For example, in GraphQL I would ...
- 579
4votes
5answers
11kviews
How can a web app work correctly when Internet connection is lost for some hours?
Our team wants to design a Web-Based retail pharmacy management system. A web based solution is good because no user installations are needed. Some of the data fetched from central database are read-...
- 207
0votes
3answers
4kviews
For what kind of websites is it ok or even better to use SQLite? [closed]
I'm familiar with the process of setting up Postgresql. And I'm also thinking of using SQLite for some of my websites for I don't need that much functionality that Postgresql offers. And I also want ...
- 85
3votes
1answer
159views
Data to pre-populate a database kept in text files
Many web application require a seed file -- a file, written in the same language as a web application, where I have data to pre-populate a database. This makes sense. Nonetheless, I sometimes see ...
- 67
-1votes
1answer
143views
How to make sure I have the contract proposal approval in my system?
I am building a website and in it I am trying to follow the rbac (role-based access control) model. Now, the thing is that managers need to send their contract proposals to approvers (people who will ...
- 489
3votes
1answer
3kviews
Keeping data between two databases in sync
Let's say I have a forum application running, and I start building a separate web application with a Python web framework. Both applications use their own MySQL databases, which contain their own ...
- 47
